SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 158711 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 158711 [ RunTime:0.002382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702988,393070,1029520,292220,408197,426907,496900,402535,667214,59053,951302,1019863,855455,936416,114218,207120,350216,156760,249386,96713,562232,125888,87413,498505,851400,972338,77401,776994,709272,901130,845520,307210,812148,382741,140741,407136,153650,167247,798998,122262,169374,323299,74386,573050,646522,863760,925496,739147,888145,544873,785608,467952,350883,318182,922950,635108,922516,461508,1020280,1011454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 158711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 158711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]