SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500366 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500366 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800544,425130,182394,521985,361213,77778,640020,344813,40036,833022,454571,78811,287350,242166,781762,947551,39223,231037,869401,972228,48507,475396,523394,357847,254451,204731,854916,22599,206101,397632,487354,476177,965965,851277,571493,154880,605709,586025,661621,745206,665933,698263,489364,902622,300091,722731,303083,680161,956367,26107,1044360,665007,137505,922097,34182,675597,734276,617821,637336,399048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]