SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404208 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404208 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911114,1030978,860481,854242,294037,602427,1008236,1034893,531223,8048,1013439,255699,488712,991695,441616,990694,518515,921360,185625,92695,539176,217695,684939,774488,295039,58638,932128,71517,958115,280044,26057,764868,966058,240928,841622,40472,258479,914352,1003532,1019439,536759,812512,315273,956482,172796,1007930,1027545,209567,786420,125311,164557,1038710,366049,611423,516837,679278,284190,698438,1023126,666263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001165s ]