SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043414 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043414 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717764,506697,722522,314687,43486,439748,474917,788127,298276,751746,588434,340277,941318,259369,330969,211820,1032076,492146,731423,720784,528450,441241,45922,323481,992999,556954,771255,914630,359249,511038,108478,480551,477669,480757,580484,180565,579395,241139,1025889,853548,422681,57509,570897,926139,823,601516,131887,444550,219921,422881,494293,760636,67103,237628,862732,638827,52892,896106,850802,248519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]