SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498569 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498569 [ RunTime:0.002537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36985,185228,711050,418333,394327,711861,796993,295720,285138,29713,104186,190993,1020465,855386,174351,273944,908159,812434,127401,441997,136966,289564,678606,504021,1047933,766211,865676,404077,771488,361687,886705,318644,31841,507685,306982,585225,1004530,683773,813040,41510,800516,444246,695652,496425,275488,639298,768715,130883,1000882,936721,994003,854949,553853,93021,977664,72326,129961,844402,421052,95523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]