SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54333 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54333 [ RunTime:0.003232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714863,913720,532274,454180,708966,553061,40224,344849,118057,504025,450266,184489,959554,480325,135596,216951,351421,961820,921948,218970,340627,238736,734814,963466,751559,242757,144179,376458,782105,243440,123958,1016473,28164,561767,698000,810047,690509,545593,937491,937985,690140,826630,118213,442725,482981,808259,391062,770395,307241,359378,410061,264641,137554,793098,338385,41613,926188,418201,729733,361252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54333 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54333 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]