SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475781 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475781 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452485,617747,762295,378991,63202,546267,327314,49180,7543,335392,129996,256402,401027,642018,722252,462290,1005410,628275,414635,641044,319088,508148,735637,711733,763489,36731,413422,594232,906174,174809,456887,117075,977699,614879,829548,334867,661208,495111,476001,535846,210015,299387,429445,712149,483994,1013236,256733,1039742,698045,941208,280400,447696,535636,922215,882872,545262,57135,790653,986162,1029890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]