SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580433 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580433 [ RunTime:0.002103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138692,671274,246604,422591,810718,192545,643068,52030,596528,161657,476725,534037,101841,994949,229838,441470,660604,418546,595258,273236,685395,427390,775809,806124,697909,139815,827960,92198,18445,981983,313132,827282,571472,357143,538080,959090,962445,423433,725254,702594,219687,96686,445773,7132,185283,58273,668314,117302,733710,544991,678030,712567,958207,795024,566246,402227,630162,800532,234808,933533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]