SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26014 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26014 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145511,196046,686872,291828,246015,274702,184032,974082,434849,595480,152359,562812,858847,1036752,159506,1000054,578535,131996,531507,25580,766908,362133,186097,96331,71528,147571,545192,955833,527538,277594,51318,228576,8014,953260,432069,684297,724274,775987,482443,970001,431387,335695,117578,878959,955571,440623,586715,233648,403053,24332,365805,550709,353936,793346,583959,931078,324995,207040,19241,360280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]