SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190418 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190418 [ RunTime:0.001434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410873,870168,890831,858956,537473,647719,876178,1033073,269211,79046,1008778,1023788,889044,942938,358503,165279,269496,738257,627807,181494,756351,630004,565831,745220,961503,212909,486823,294402,547135,1018046,388634,90377,284198,976317,992368,21425,840464,58358,70809,650472,1036548,729862,974392,809307,675690,529561,820955,337243,997109,40945,170461,700191,575606,718607,683764,780312,698103,483411,316527,841988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]