SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50790 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50790 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880410,316166,552655,854354,1021595,702443,457212,10601,911791,390617,458199,560291,563650,1003433,42758,966872,50900,128527,535350,270857,787826,111979,894019,339238,308193,997390,339405,905442,884013,635398,300817,517063,35677,791868,152089,1003858,974199,368862,284390,604289,540727,955267,985512,996326,746178,958915,444115,242266,564072,564807,773232,175737,300262,217490,689121,19337,511475,47642,227586,625136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]