SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299568 LIMIT 1 [ RunTime:0.000929s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299568 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143288,3466,636276,103258,683482,48873,327655,397638,438137,345490,347982,270947,847972,487998,70772,364899,669417,818630,455517,1042542,712752,160948,233270,955773,110999,427932,345180,321769,1013465,422084,312160,520045,173743,1036083,682603,1043691,801953,635968,228294,509230,773340,1013643,258479,172583,843973,9990,504142,921927,96774,321983,739592,439090,74440,883965,351453,185027,844346,192928,924778,435525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001174s ]