SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566096 LIMIT 1 [ RunTime:0.000680s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566096 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691927,118192,375298,444173,367374,874315,792441,181875,677245,115508,419432,976401,824078,256341,863658,450982,835799,283932,721412,677322,846011,280502,618757,106958,688844,945697,778286,688510,350430,840462,441981,172185,569692,130758,235788,37476,385541,513171,669288,391094,940356,533163,208388,75208,800534,156375,814050,949559,27265,421354,607149,934321,945150,783096,333816,125714,314014,942838,319647,36489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]