SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292211 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292211 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455208,340395,831219,754807,446729,558505,763759,326188,935867,736721,619792,847921,311822,298298,643480,1044183,525434,482861,650525,42226,36650,148446,586305,491344,215328,863316,473304,83345,346637,100566,547552,782592,579098,1022532,949046,902549,369102,1022028,4247,747982,675670,475849,307415,1030815,145983,385235,675727,227385,360543,126526,66196,1015236,529548,237270,892430,432019,967003,328403,613279,870913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]