SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440159 LIMIT 1 [ RunTime:0.001237s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440159 [ RunTime:0.002116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697346,664746,10951,968724,294135,109721,547027,405321,685919,542849,789633,905423,907508,876753,803893,115669,504445,514084,1032904,45999,358452,558924,9434,418004,916033,1040606,426632,624954,526251,795135,762684,456940,20066,81057,379962,885539,375569,861198,174617,764984,318601,79085,584631,356535,117756,354798,644065,896121,278295,414654,200484,77619,936106,869992,803744,356297,16822,679289,219291,858891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002434s ]