SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476041 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476041 [ RunTime:0.001464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710952,688711,383100,76011,1001727,651132,948745,472995,314455,877385,845470,997609,131869,492693,584660,563666,66416,620157,1019887,910479,68129,505634,1044504,357678,581921,923442,470888,490919,887273,475453,1044939,294667,369754,456735,15658,700707,345051,309039,20488,305086,778936,442024,51151,903982,684755,551362,99167,30235,308670,1028379,652582,399998,505999,831185,22510,7158,905303,212156,285703,753931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]