SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004496s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396991 LIMIT 1 [ RunTime:0.007824s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396991 [ RunTime:0.008507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929217,325223,300449,178065,722887,487482,635332,911719,558702,885878,335535,717450,354407,811691,558864,469830,1031677,940681,274398,810093,390968,671492,783111,505699,682427,45200,831570,381057,695638,50473,73812,696318,756400,627337,235558,902530,582151,594732,27824,5105,12142,887382,807222,556856,355533,31736,351165,879945,914919,514600,1629,949932,795634,279916,931474,552098,667421,929967,1023615,346714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]