SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487035 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487035 [ RunTime:0.002621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958371,400776,847496,656765,3192,704341,418394,480182,528843,529458,113394,1047951,351841,137273,180003,518925,484287,110449,918705,675205,286088,705267,728806,118897,360225,872688,641348,249820,208339,831974,532443,778811,323473,53171,606877,807776,8890,717340,129388,546707,69625,426604,253174,233200,593316,103029,555622,337354,833444,266292,1030067,773033,449898,940506,426350,637393,729317,388796,859593,304826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]