SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861055 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861055 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160064,35231,959680,50686,614147,585670,143440,725557,472234,192443,181463,291558,531610,974220,260505,203192,304934,99600,878004,50294,912964,28717,510163,231263,521871,845909,352610,128851,668717,435937,996216,414040,506367,177967,528908,1022520,382259,816661,276319,358113,754259,398602,254208,365561,397820,791013,788032,182534,143461,83130,784646,1036879,406050,345963,494448,551190,937484,388152,333330,492122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001341s ]