SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 975308 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 975308 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138107,704119,73269,998133,210750,760751,593880,103094,740103,709764,987364,733359,527032,397506,187609,650898,174571,904150,352948,501529,742828,138986,357678,87257,896328,383348,412475,380125,383181,891440,656185,946170,625651,152278,1029418,929626,291833,545994,82044,669259,86200,391914,854732,413925,20268,597526,630345,176705,1020049,503802,1003976,85635,651787,223008,599084,993326,560124,639066,967893,265774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 975308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 975308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000949s ]