SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266484 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266484 [ RunTime:0.002910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613020,480244,352766,35668,424161,166652,898191,388182,326855,505985,895117,630970,423904,982250,920502,47522,664597,283347,664546,354878,64453,825518,292161,723307,1026176,1013184,210862,202872,220797,609718,784733,52513,228162,23543,924388,806824,176842,654744,722130,171499,615759,871879,347512,141503,223367,120855,259165,550583,992201,782824,344177,676628,514445,158216,500044,690060,659923,874752,853671,367051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]