SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003766s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461975 LIMIT 1 [ RunTime:0.001947s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461975 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2501,480780,94842,113183,1001750,358328,704928,1040620,530734,703968,819919,80550,933537,351609,1037832,620443,777965,419866,1016256,696496,669289,859018,447987,769265,154075,712680,696160,709463,1048484,118075,115510,434498,252984,283158,1047922,901298,765188,813815,120868,54462,211790,917207,948877,32219,361548,847548,522869,10582,253474,41385,728362,891121,381586,64970,676315,505858,911099,712171,112036,404007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]