SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416904 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416904 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285081,528798,167304,509119,977453,668515,205821,7556,879127,129880,302041,956165,192058,622141,810044,386281,432930,595436,827275,393315,942986,202399,832204,24036,853959,246276,634464,967214,676328,20971,121751,187823,403606,919587,1041947,926971,424193,385469,229942,723955,15132,486267,48392,389100,368974,426142,907113,581778,818950,663161,993675,170130,97154,636578,91653,848422,132017,348917,883002,880080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]