SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010060 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010060 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642848,480361,630893,596653,342017,187244,216717,667895,436467,100847,888316,551824,378876,631165,699211,796299,893906,1012390,688858,188607,492671,527770,137713,848367,282643,21376,941709,13942,390999,66578,728627,594545,640222,136119,125605,736302,450689,747695,1047845,320838,876487,230984,457692,970974,199402,210276,1010418,13973,83995,632078,297791,238932,355543,829331,442266,536938,499879,360241,115764,733978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]