SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 849943 LIMIT 1 [ RunTime:0.000710s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 849943 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909462,874036,567874,1028683,706949,778192,227558,857877,290012,757111,989125,730277,907452,808486,774242,556968,296704,197321,869977,875178,622076,184899,1035369,115356,524719,652908,798257,228098,910268,537490,641893,381738,867884,555675,177273,268460,225446,151086,572974,112236,326701,383437,472207,699627,919537,540654,39571,434449,969871,432633,853500,140541,534134,992336,616635,260993,535957,608044,102795,418719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 849943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 849943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001107s ]