SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004693s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510448 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510448 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429159,157004,939004,660366,196313,995511,36526,890209,142454,852935,896004,313543,604132,489885,859518,70543,567716,748637,612833,966421,936581,379257,742353,845471,815676,999782,230772,976424,449119,879835,592279,260611,549862,1034991,717723,384407,76326,831476,292777,358594,136260,972622,721616,258603,27603,120252,773545,401462,33827,796867,449220,452310,909278,652541,729408,883465,941676,791047,357661,769772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]