SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402987 LIMIT 1 [ RunTime:0.000559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402987 [ RunTime:0.003686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602142,564404,907108,770153,324754,562698,376705,168595,115192,831666,399397,330791,231147,640617,927588,404669,156018,345635,375464,98992,363872,766990,791111,171839,1002264,687429,438632,14260,287275,1021548,660800,102844,510843,544922,621813,298536,361243,92090,803480,107590,991915,883826,119391,318025,91607,620601,987600,823994,814247,603373,195731,701959,295002,495284,920000,811773,71528,426424,564227,225684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]