SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430089 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430089 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942947,833180,67837,87637,658732,446453,545821,1023286,86311,498493,865305,145393,155567,358226,410099,455052,984935,390183,862989,630654,35706,11716,289245,394271,627325,691217,19907,649297,343677,674315,833127,563102,943493,165103,77179,396237,855255,567612,821070,145576,601774,469208,287284,505711,19646,1025847,141619,701160,678567,825604,368420,925249,338291,69169,85209,1043432,233642,852743,987015,441248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]