SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296724 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296724 [ RunTime:0.002494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545146,176013,914642,898993,344769,667660,1048402,965474,735166,652628,653910,346158,140737,564026,122717,300799,967602,1047481,917904,236203,149629,269614,831264,184351,15943,872444,722393,1035035,421487,271571,404664,774898,882601,298214,198047,135973,59256,778070,371804,872071,281729,164377,981621,35414,13403,655627,785731,937465,465512,926122,211452,984966,46598,915186,788376,423368,395660,346472,133360,855035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296724 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296724 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]