SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433443 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433443 [ RunTime:0.002730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028089,1027030,320651,636011,350332,818382,798643,475522,67242,101655,77049,147345,803802,770829,697348,20580,816678,538595,29634,687196,951553,123826,411829,471376,53096,856021,822886,740488,369831,241768,77367,513816,986268,269645,387239,406642,935652,162820,640436,148673,49805,123014,801213,317269,452896,522151,380594,807239,305900,615977,198174,599359,73331,612528,984344,101673,256163,351174,125291,1000509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]