SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101621 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101621 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695575,44669,940718,370040,684338,692259,699378,673135,485026,542416,163257,627710,48730,27862,733855,438189,736120,742739,953442,714178,874731,596389,763586,691629,580824,1041039,749642,268099,693049,164297,748743,962581,163723,563558,29124,674820,713511,380216,744255,814723,342747,370979,237404,601161,730585,910236,420755,712043,13505,1038416,832335,404804,966647,457668,14238,745415,115505,946053,510901,621840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]