SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027809 LIMIT 1 [ RunTime:0.000585s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027809 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345755,946624,604765,136875,147190,1031471,47749,645137,838947,1045822,721187,844652,366809,68159,171187,102607,908324,705957,1003273,675954,926708,628892,603126,678008,734949,795829,592617,82698,512384,326864,844685,667802,956377,287893,954242,814897,780635,512341,877036,137214,79858,419143,203854,135804,981706,158488,1006709,321818,230847,926906,750099,386667,956003,682003,679243,557906,930827,472538,74035,1015744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]