SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402187 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402187 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820254,885184,877077,254835,19171,374843,1018070,942788,608633,583927,694596,652593,978560,208092,560153,861113,599533,418140,686537,1006231,343100,610477,345034,923216,82815,425857,661572,1026872,424,733804,715956,500127,1013579,1002723,959193,857492,36730,136904,464584,919478,692554,264991,980101,269233,1028669,98388,373563,207673,616150,851936,531496,946279,36067,490349,612311,950569,241964,1000077,156336,902670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001842s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]