SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399694 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399694 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814056,804623,795886,782407,897932,333122,788230,771772,122417,626561,840892,144315,959512,387495,434121,375072,170967,635818,656996,81980,316489,160655,808614,513174,719667,419381,559982,401771,242265,256302,314917,179171,76608,648294,1040863,937090,892073,259183,669223,301435,824143,112205,147519,312756,237577,164858,174869,782998,147686,289782,660703,352258,647342,332857,228610,15506,1040187,460594,917693,405921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]