SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 169201 LIMIT 1 [ RunTime:0.000995s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 169201 [ RunTime:0.006667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584005,842909,947741,1025588,120699,392279,574907,84253,894955,832007,383859,135889,15550,554728,712326,596325,20114,830324,167951,491004,222046,622007,84604,190633,427207,449683,206195,917692,106167,815992,833321,866464,249073,276477,1006019,569933,763776,524349,254451,738192,128571,391226,304248,252682,623371,996825,837050,377789,28486,965075,714811,40077,208255,829063,798548,649302,995977,200964,229829,685060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 169201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 169201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]