SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416765 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416765 [ RunTime:0.002612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146398,502630,554609,923848,507474,427943,78807,856172,116123,722923,788184,686276,451537,1011919,168718,295458,827606,531281,322630,1017657,65246,214597,596582,24177,816508,723016,244304,157150,1011212,981063,833741,400323,66628,147857,435763,784128,298928,308103,48959,347197,149971,21089,144371,15525,472278,857704,685226,674378,648432,896776,973642,733450,836876,1047198,201906,180349,837594,633669,350387,126961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]