SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003812s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269494 LIMIT 1 [ RunTime:0.006153s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269494 [ RunTime:0.006819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375719,45411,325427,789589,343415,368991,901513,424391,201659,322713,143596,365447,1007274,253287,153067,924102,12512,115334,1039983,1039312,697977,170590,301201,966781,42958,361877,290272,326160,238175,655736,420120,1019873,1019870,1037326,752368,66546,856260,702636,692160,872507,648334,641488,678057,130522,502079,346361,791393,287918,526357,946350,22543,323023,636606,809611,337105,710226,917612,52877,233492,652339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000890s ]