SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416551 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416551 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660897,290984,704421,871861,967608,132909,422833,587979,269227,817920,92090,480003,426022,345197,153786,378333,920595,696108,7266,915673,113799,421552,513129,1025767,1015389,904074,356478,1025180,758461,228035,555706,1002207,29113,162923,1043719,841483,73521,580185,38287,255762,1034439,952236,435392,349220,186019,726121,799349,569131,951840,153770,658612,539951,427327,59087,5379,712819,164436,221020,978563,499622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]