SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513040 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513040 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750375,707908,820606,612450,1018204,108066,962121,22588,156505,536429,559831,83668,965143,255660,513451,644492,358458,977210,5650,210022,914298,699192,387286,154765,825876,255963,236417,777587,201830,1010152,371652,937483,926235,531175,61451,318201,782975,901531,48564,663204,1047472,688443,308434,404481,995429,80750,43180,697744,540415,138325,841176,45678,680668,701449,934400,522236,255008,433037,912576,424875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]