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` = 157178 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 157178 [ RunTime:0.003300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199931,1008017,1018093,1020246,1031976,50800,563439,256080,817091,339458,681248,429828,1018356,545301,1008947,460832,676000,557609,874652,581054,57638,468766,645920,647018,715872,797014,90845,587628,410374,292729,456023,505633,728721,482683,506492,699093,327167,9715,160540,645429,532710,498090,399988,462957,841735,637372,756562,230114,208894,769214,892393,344033,468595,535657,809216,527988,41507,314351,482246,314667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 157178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 157178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]