SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509915 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509915 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698907,1022745,367805,546293,797930,672972,849169,841314,516384,721675,658221,446792,832286,806864,127486,378422,41482,519468,730373,907313,227674,908041,249924,992864,720028,119941,154412,983568,833259,245175,666588,796890,54664,136949,631622,716209,386146,641033,837289,776594,127762,572639,435351,8825,368224,576677,2530,690251,513213,730608,113724,365488,749372,643607,35070,9066,760657,765150,756404,805785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]