SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407274 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407274 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102434,603852,698155,682551,935120,359469,442636,1047944,999352,714886,187879,307249,63811,372558,544800,277685,506648,323495,90762,412561,764750,87586,650271,49097,761424,856148,372120,275142,233630,918278,227365,110407,561432,271886,762055,519218,1019716,540239,554483,637811,599778,1004404,642110,487638,718025,455491,348199,952435,449468,526426,512476,242229,163426,153541,700893,928416,814187,701887,474250,230276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]