SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409458 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409458 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145973,420192,899546,530086,915265,1046860,640944,90321,134607,488110,679750,276450,376867,721796,268431,720844,991445,649359,50008,209603,689240,710365,568851,275631,452475,604260,256626,822667,698256,1116,657964,368498,887595,617880,558923,440915,152163,204528,76734,882892,875884,472688,808481,969004,99564,83323,712349,259992,267082,588525,992775,82825,273827,126041,273555,495685,17768,15893,1028247,472031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]