SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302876 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302876 [ RunTime:0.002715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402720,109457,1014655,676334,842011,945759,174834,381500,335716,701578,992296,363517,337388,256287,958580,967381,1003517,484365,266975,512965,707969,308229,127430,1023098,365760,948922,781171,673898,546617,483256,531796,19798,236870,262846,762054,1034290,232771,345891,317597,206065,378083,741836,547720,632198,410441,1003136,265518,185726,228008,385059,624333,327301,24703,303472,1028991,642385,754617,786012,129351,1026473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]