SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481243 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481243 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837019,772941,551126,603615,987705,813964,699109,777221,603018,40033,264029,624772,444558,213769,241792,626248,945870,505202,857916,904119,391773,145378,203094,250966,283839,848432,447105,558359,441478,198047,528821,760011,999402,1040781,489588,107530,219448,757648,422783,675913,301551,155192,1036305,771675,651334,419244,613095,757035,150646,78128,499880,386650,1007310,113220,640449,741463,495031,785946,479409,2391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]