SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327574 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327574 [ RunTime:0.002884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017920,490067,391465,961864,914440,551721,200898,4291,1022222,283911,386268,928389,587258,29807,222788,341701,387866,467615,422794,426059,206978,765659,939695,121492,1034388,165001,488240,833863,225270,389976,526453,391687,578713,198654,581621,853402,230942,357552,826429,981957,320487,386265,950758,743897,308907,343258,231088,799583,190707,95273,457896,1031956,132910,1032701,356553,102703,677553,673756,36548,166611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]