SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525928 LIMIT 1 [ RunTime:0.000621s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525928 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732803,602345,434305,18999,7832,82728,638983,832362,470316,596828,510647,91953,416664,382692,246460,699193,623747,733937,278859,671891,29197,435424,456630,566189,199695,192607,20269,619387,593915,41450,761028,478485,488662,986310,375149,690699,719596,994337,777575,442584,575591,804008,1010563,350815,112885,39213,468848,259974,178961,859613,173869,655529,135511,505480,81693,628231,641657,471671,515465,733540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]