SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.009758s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682009 LIMIT 1 [ RunTime:0.004016s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682009 [ RunTime:0.003430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32970,183196,730044,135509,547965,755606,863491,239489,811875,942916,193577,17488,265926,331540,642408,981393,83624,934809,924371,736677,402119,458786,201176,72154,908296,1020076,877690,252981,167119,1014094,39445,738777,122617,802439,838531,152116,699630,139345,523168,634238,275468,387681,480596,909655,513292,204720,595026,870752,376925,151092,401592,916666,816003,387438,460482,220809,453405,425647,103685,1020079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004839s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002168s ]