SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016608 LIMIT 1 [ RunTime:0.001847s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016608 [ RunTime:0.005233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252696,543136,927922,167760,65026,32554,418043,648124,783350,1004381,505008,95789,226124,883898,1044763,561080,748623,883988,1015200,840834,396079,513047,351530,512562,1002178,861928,387697,897609,778409,845048,474674,254917,547402,576135,358814,940901,268197,971899,700905,48435,359350,295093,1030865,312445,902917,826610,1047415,29599,96902,498010,469980,810036,1009902,813614,1036257,343656,617865,223375,571682,109780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]