SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314963 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314963 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182008,1024051,857273,503214,382140,993431,376597,887823,605374,600449,1028316,410050,307080,931688,29223,517019,344747,500188,799447,159907,903122,589235,1044881,102538,899969,831724,309367,537679,766849,455231,909767,259279,1040540,629227,520730,586671,758956,871565,240264,870810,620399,609268,118363,440509,823577,157743,802315,190714,75565,981023,432687,28609,107108,1030199,686106,412163,998085,894135,354869,452093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001639s ]