SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 730243 LIMIT 1 [ RunTime:0.000891s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 730243 [ RunTime:0.005177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577807,438744,655977,154711,20434,11433,665543,298467,274967,202783,921103,571479,609340,434289,415675,113183,706516,319037,811225,810208,615002,386265,295439,561470,659985,825014,181439,766064,873172,304225,167903,1032480,352845,407356,921317,396729,408544,620449,750470,191477,856147,264753,884328,219403,953354,385783,494404,928300,353980,856128,439778,996282,938166,191155,154205,622873,730965,694636,570942,332178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 730243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 730243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]