SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045814 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045814 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585848,800766,511262,169390,311702,225449,533074,391563,531845,16112,222818,675919,285334,62875,155075,920142,519050,446196,307183,672854,546524,603871,919757,812718,219705,859269,683466,269982,831181,82279,819038,422122,60727,19731,592479,353397,566343,536563,756397,400957,219128,870014,575506,818667,437281,953915,990981,761492,501983,834348,998099,528502,777218,1039143,992795,237645,697022,408665,86485,338615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]