SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380175 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380175 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495148,150973,338863,187021,14831,293763,857469,758675,126189,98413,111503,5726,918768,773669,850593,926058,198381,101978,586652,518785,232615,324212,779886,319363,354190,551094,73017,666610,1048893,1034974,848954,424476,227049,188970,297864,101327,717047,171693,608154,864587,875272,614169,937002,744657,690304,973284,1029291,194879,520698,946052,31937,167311,28051,290889,4564,330160,347329,483777,163583,271407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]