SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 66341 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 66341 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940393,392105,978942,1013107,331410,498303,454508,465739,713958,823212,726219,847527,470421,185235,939642,101350,596457,1045900,228384,471467,297297,1048442,405402,311962,487630,935179,622184,742574,681764,390540,941589,419186,271315,896163,906694,523642,271441,305968,1014895,443568,779739,1006547,841692,770172,149064,86828,265722,377341,569515,592058,155656,413432,406680,279350,270504,559617,651784,945816,173217,37926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 66341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 66341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]