SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490276 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490276 [ RunTime:0.001429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027007,962534,136291,1031414,233920,343391,310848,312636,34305,480716,69849,796164,946234,503670,569382,901166,373444,481104,108833,370881,158627,884684,829742,505045,361130,563788,402024,338196,830635,99427,549431,34871,324682,6081,815018,594393,786771,777784,535160,879889,917776,898306,330907,208013,95031,875421,416352,856303,859800,392888,522686,277475,763900,966914,756446,459735,608890,953174,498568,475471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]