SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482208 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482208 [ RunTime:0.006343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324641,39987,469462,983448,128978,1043944,306525,197380,818099,13599,840858,819069,480941,669269,349045,886912,322724,381170,572828,1026504,2097,406851,288538,108309,483554,307997,915001,232526,186998,767814,387543,1025411,825958,881846,955014,297990,257187,569991,109458,558412,515287,1008728,406726,380413,920121,98481,910238,97069,580962,273417,967598,572794,984795,56870,239537,128887,1023584,468913,1024098,803221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]