SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009083 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009083 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398518,265446,75789,686091,951889,986708,37351,517279,721848,415560,649785,296315,443125,766461,114567,389847,647989,366263,779927,890178,181833,1011265,582362,323860,141502,523375,967925,347339,405719,725238,1009127,35265,766273,344545,822114,709527,506308,996205,20237,287820,515624,771780,183039,624298,744149,951771,535132,312486,244758,694240,272778,209968,682790,863779,703749,237032,975197,936651,617078,930555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]