SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387623 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387623 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34453,372340,322686,713278,51677,454461,845693,867126,946101,259627,727194,810856,676608,795327,988921,791109,168960,445185,400230,224580,232397,951715,299106,994586,64888,200131,780435,191649,532146,739130,770659,832814,745200,813361,432403,143967,1418,980538,114704,455151,961689,819375,627044,833248,677004,1021740,548455,568780,280652,796204,562231,414219,615197,904037,975609,334958,902856,918542,672203,417450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]