SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500261 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500261 [ RunTime:0.002717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123821,345965,750345,870872,298042,190516,586985,646746,904287,387358,531219,911897,174430,733256,579060,145949,959599,979401,345073,682095,571346,236270,869066,935733,994659,808998,296484,838816,924468,959591,151877,969489,776980,464692,22341,152539,282075,924237,242373,360916,788310,758348,982444,491554,245550,593927,5513,558999,606417,339737,582125,527400,1016070,197554,119298,160958,436558,448697,87117,880458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001510s ]