SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444704 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444704 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602435,415161,339643,717233,168026,547261,552798,581121,771695,478937,975502,825443,692021,905027,984840,928152,34564,520049,860385,738870,735735,864427,174906,624941,1041305,353541,716331,211915,718911,669526,728266,421483,65598,907707,89009,351373,639511,308392,137812,894263,148683,1017868,813588,394717,201803,217598,293078,396907,997448,852993,536806,117898,110560,628616,441233,833523,587250,199801,744270,1024267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]