SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146213 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146213 [ RunTime:0.002401s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95178,1028731,98060,795624,488068,776953,112593,457333,351466,437305,920771,421620,610341,248288,606018,378519,328883,430585,642354,191317,436431,755679,950659,173369,545955,87894,143856,225845,781980,627805,1031944,449192,424153,51622,1007590,521940,813375,75996,658399,301414,307601,557240,684120,352109,446870,353128,17317,644374,460981,742033,736865,798210,640205,393849,270930,996366,327900,374529,770294,670428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]