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` = 106423 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106423 [ RunTime:0.002657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64315,914707,844321,162150,132868,672413,66530,2017,1012932,777897,162497,270867,753466,624042,64518,472757,975822,308944,88941,869509,697609,617747,371042,153373,238863,175520,952423,28908,522922,820094,46901,486198,899265,606898,485425,77232,498589,363339,467657,314220,569322,132311,146627,735632,220280,588756,774743,932977,602528,845280,518118,244439,676290,510152,824209,122109,79107,1003171,1023450,390952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]