SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420713 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420713 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776140,1004882,250877,321914,756054,116010,293312,779269,198758,234570,457338,744406,550474,669930,111241,137597,418382,999369,669963,247132,213053,162247,562546,222661,785761,112736,524053,936217,731280,472535,629884,338240,727768,572068,344844,20797,401994,1020901,124138,282988,1024135,638867,557199,725762,383102,900822,850476,247614,304950,122226,850826,1005327,16065,571290,200345,950954,1033101,755159,375403,445869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]