SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501086 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501086 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23742,187432,378024,325026,501001,891508,995395,105536,848453,777863,771351,777932,968711,804471,1010060,1044323,24132,130200,1018042,824252,106754,1015326,801297,979497,84968,134567,48810,350848,878092,861748,512690,811367,278885,599227,206559,83938,1017039,410482,680340,894647,486216,961191,977025,203009,784958,973510,846839,870344,585568,171272,424100,275658,276519,391429,365292,59437,122112,331771,181856,601800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]