SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103391 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103391 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285630,614425,842517,507055,785596,566463,163726,885285,731402,517723,244557,515085,386742,1042311,552908,459417,750161,981203,819201,377214,973830,1011692,615520,791513,235802,702072,408623,561903,624528,214353,648719,1001713,813086,766469,934589,749958,662077,585633,91135,361039,305914,799024,1028841,328293,259264,156156,260913,329941,1013961,259409,674693,499621,567009,404534,480928,577858,748940,562443,756827,464936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]