SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101105 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101105 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41272,483133,1006706,58883,986371,627443,771488,33239,560838,1025732,814583,329035,186262,178639,562027,864305,959163,490992,957676,214999,598948,678365,745915,256786,1041660,924569,416694,742033,166119,155083,86438,202318,823253,413748,1041676,942086,308791,610247,145972,490045,660556,220764,756929,448880,812468,356338,1036298,514983,813631,943650,681749,386083,967105,628010,564867,379590,722533,608645,146618,647196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000370s ]