SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437921 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437921 [ RunTime:0.002938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659059,297983,143374,360018,765044,785774,359931,920129,924813,983112,135232,761335,513114,766740,380506,549488,343880,396691,730099,43111,402984,967839,930414,879010,296094,981546,673431,61972,170632,650148,1006617,298225,1031660,290966,1034718,397621,958157,44919,681006,246405,67650,126892,232358,121561,464536,131479,109831,553422,367336,407269,97994,265516,581975,307326,164767,149849,355316,369486,385374,311922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]