SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003804s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681861 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681861 [ RunTime:0.003314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320039,548975,444772,695437,841541,673659,650066,392454,149544,316734,875757,757812,1004886,912786,105492,317659,511274,1020014,947699,488105,373618,852560,197680,952963,736775,382866,351479,261380,1014235,1046270,61432,623289,480790,796890,878807,863999,651101,395811,701751,759586,414090,340335,40622,721781,712531,908784,230075,642974,431655,689443,492781,644840,38347,400076,49543,569058,244565,190222,755006,755019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]